<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<head>
<title>Source code</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<div class="sourceContainer">
<pre><span class="sourceLineNo">001</span><a name="line.1"></a>
<span class="sourceLineNo">002</span>/*<a name="line.2"></a>
<span class="sourceLineNo">003</span> * Copyright (C) 2012 Archie L. Cobbs. All rights reserved.<a name="line.3"></a>
<span class="sourceLineNo">004</span> *<a name="line.4"></a>
<span class="sourceLineNo">005</span> * $Id: XMLResultSetWriter.html 883 2014-05-07 02:45:34Z archie.cobbs $<a name="line.5"></a>
<span class="sourceLineNo">006</span> */<a name="line.6"></a>
<span class="sourceLineNo">007</span><a name="line.7"></a>
<span class="sourceLineNo">008</span>package org.dellroad.stuff.sql;<a name="line.8"></a>
<span class="sourceLineNo">009</span><a name="line.9"></a>
<span class="sourceLineNo">010</span>import java.io.IOException;<a name="line.10"></a>
<span class="sourceLineNo">011</span>import java.io.InputStream;<a name="line.11"></a>
<span class="sourceLineNo">012</span>import java.io.Reader;<a name="line.12"></a>
<span class="sourceLineNo">013</span>import java.lang.reflect.Field;<a name="line.13"></a>
<span class="sourceLineNo">014</span>import java.lang.reflect.Modifier;<a name="line.14"></a>
<span class="sourceLineNo">015</span>import java.sql.Date;<a name="line.15"></a>
<span class="sourceLineNo">016</span>import java.sql.ResultSet;<a name="line.16"></a>
<span class="sourceLineNo">017</span>import java.sql.ResultSetMetaData;<a name="line.17"></a>
<span class="sourceLineNo">018</span>import java.sql.SQLException;<a name="line.18"></a>
<span class="sourceLineNo">019</span>import java.sql.Timestamp;<a name="line.19"></a>
<span class="sourceLineNo">020</span>import java.sql.Types;<a name="line.20"></a>
<span class="sourceLineNo">021</span>import java.text.SimpleDateFormat;<a name="line.21"></a>
<span class="sourceLineNo">022</span>import java.util.Arrays;<a name="line.22"></a>
<span class="sourceLineNo">023</span>import java.util.Collections;<a name="line.23"></a>
<span class="sourceLineNo">024</span>import java.util.HashMap;<a name="line.24"></a>
<span class="sourceLineNo">025</span>import java.util.Map;<a name="line.25"></a>
<span class="sourceLineNo">026</span><a name="line.26"></a>
<span class="sourceLineNo">027</span>import javax.xml.stream.XMLStreamException;<a name="line.27"></a>
<span class="sourceLineNo">028</span>import javax.xml.stream.XMLStreamWriter;<a name="line.28"></a>
<span class="sourceLineNo">029</span><a name="line.29"></a>
<span class="sourceLineNo">030</span>/**<a name="line.30"></a>
<span class="sourceLineNo">031</span> * Outputs the result of an SQL query as XML.<a name="line.31"></a>
<span class="sourceLineNo">032</span> *<a name="line.32"></a>
<span class="sourceLineNo">033</span> * &lt;p&gt;<a name="line.33"></a>
<span class="sourceLineNo">034</span> * For example, the query &lt;code&gt;SELECT ID, LAST_NAME AS LAST, FIRST_NAME AS FIRST FROM EMPLOYEE&lt;/code&gt; might become:<a name="line.34"></a>
<span class="sourceLineNo">035</span> * &lt;pre&gt;<a name="line.35"></a>
<span class="sourceLineNo">036</span> *  &amp;lt;result-set&amp;gt;<a name="line.36"></a>
<span class="sourceLineNo">037</span> *      &amp;lt;query&amp;gt;&amp;lt;![CDATA[SELECT ID, LAST_NAME, FIRST_NAME FROM EMPLOYEE]]&amp;gt;&amp;lt;/query&amp;gt;<a name="line.37"></a>
<span class="sourceLineNo">038</span> *      &amp;lt;columns&amp;gt;<a name="line.38"></a>
<span class="sourceLineNo">039</span> *          &amp;lt;column index="1" name="ID" label="ID" precision="20" type="BIGINT" typeName="BIGINT" nullable="false"/&amp;gt;<a name="line.39"></a>
<span class="sourceLineNo">040</span> *          &amp;lt;column index="2" name="LAST_NAME" label="LAST" precision="255" type="VARCHAR" typeName="VARCHAR" nullable="false"/&amp;gt;<a name="line.40"></a>
<span class="sourceLineNo">041</span> *          &amp;lt;column index="3" name="FIRST_NAME" label="FIRST" precision="255" type="VARCHAR" typeName="VARCHAR" nullable="false"/&amp;gt;<a name="line.41"></a>
<span class="sourceLineNo">042</span> *      &amp;lt;/columns&amp;gt;<a name="line.42"></a>
<span class="sourceLineNo">043</span> *      &amp;lt;data&amp;gt;<a name="line.43"></a>
<span class="sourceLineNo">044</span> *          &amp;lt;row&amp;gt;<a name="line.44"></a>
<span class="sourceLineNo">045</span> *              &amp;lt;column index="1"&amp;gt;1302&amp;lt;/column&amp;gt;<a name="line.45"></a>
<span class="sourceLineNo">046</span> *              &amp;lt;column index="2"&amp;gt;Washington&amp;lt;/column&amp;gt;<a name="line.46"></a>
<span class="sourceLineNo">047</span> *              &amp;lt;column index="3"&amp;gt;George&amp;lt;/column&amp;gt;<a name="line.47"></a>
<span class="sourceLineNo">048</span> *          &amp;lt;/row&amp;gt;<a name="line.48"></a>
<span class="sourceLineNo">049</span> *          &amp;lt;row&amp;gt;<a name="line.49"></a>
<span class="sourceLineNo">050</span> *              &amp;lt;column index="1"&amp;gt;1303&amp;lt;/column&amp;gt;<a name="line.50"></a>
<span class="sourceLineNo">051</span> *              &amp;lt;column index="2"&amp;gt;Lincoln&amp;lt;/column&amp;gt;<a name="line.51"></a>
<span class="sourceLineNo">052</span> *              &amp;lt;column index="3"&amp;gt;Abraham&amp;lt;/column&amp;gt;<a name="line.52"></a>
<span class="sourceLineNo">053</span> *          &amp;lt;/row&amp;gt;<a name="line.53"></a>
<span class="sourceLineNo">054</span> *          ...<a name="line.54"></a>
<span class="sourceLineNo">055</span> *      &amp;lt;/data&amp;gt;<a name="line.55"></a>
<span class="sourceLineNo">056</span> *  &amp;lt;/result-set&amp;gt;<a name="line.56"></a>
<span class="sourceLineNo">057</span> * &lt;/pre&gt;<a name="line.57"></a>
<span class="sourceLineNo">058</span> * &lt;/p&gt;<a name="line.58"></a>
<span class="sourceLineNo">059</span> *<a name="line.59"></a>
<span class="sourceLineNo">060</span> * &lt;p&gt;<a name="line.60"></a>
<span class="sourceLineNo">061</span> * If you turn on column name tags via {@link #setColumnNameTags setColumnNameTags()}, the output would look like this:<a name="line.61"></a>
<span class="sourceLineNo">062</span> * &lt;pre&gt;<a name="line.62"></a>
<span class="sourceLineNo">063</span> *  &amp;lt;result-set&amp;gt;<a name="line.63"></a>
<span class="sourceLineNo">064</span> *      &amp;lt;query&amp;gt;&amp;lt;![CDATA[SELECT ID, LAST_NAME, FIRST_NAME FROM EMPLOYEE]]&amp;gt;&amp;lt;/query&amp;gt;<a name="line.64"></a>
<span class="sourceLineNo">065</span> *      &amp;lt;columns&amp;gt;<a name="line.65"></a>
<span class="sourceLineNo">066</span> *          &amp;lt;column index="1" name="ID" label="ID" precision="20" type="BIGINT" typeName="BIGINT" nullable="false"/&amp;gt;<a name="line.66"></a>
<span class="sourceLineNo">067</span> *          &amp;lt;column index="2" name="LAST_NAME" label="LAST" precision="255" type="VARCHAR" typeName="VARCHAR" nullable="false"/&amp;gt;<a name="line.67"></a>
<span class="sourceLineNo">068</span> *          &amp;lt;column index="3" name="FIRST_NAME" label="FIRST" precision="255" type="VARCHAR" typeName="VARCHAR" nullable="false"/&amp;gt;<a name="line.68"></a>
<span class="sourceLineNo">069</span> *      &amp;lt;/columns&amp;gt;<a name="line.69"></a>
<span class="sourceLineNo">070</span> *      &amp;lt;data&amp;gt;<a name="line.70"></a>
<span class="sourceLineNo">071</span> *          &amp;lt;row&amp;gt;<a name="line.71"></a>
<span class="sourceLineNo">072</span> *              &amp;lt;ID index="1"&amp;gt;1302&amp;lt;/ID&amp;gt;<a name="line.72"></a>
<span class="sourceLineNo">073</span> *              &amp;lt;LAST index="2"&amp;gt;Washington&amp;lt;/LAST&amp;gt;<a name="line.73"></a>
<span class="sourceLineNo">074</span> *              &amp;lt;FIRST index="3"&amp;gt;George&amp;lt;/FIRST&amp;gt;<a name="line.74"></a>
<span class="sourceLineNo">075</span> *          &amp;lt;/row&amp;gt;<a name="line.75"></a>
<span class="sourceLineNo">076</span> *          &amp;lt;row&amp;gt;<a name="line.76"></a>
<span class="sourceLineNo">077</span> *              &amp;lt;ID index="1"&amp;gt;1303&amp;lt;/ID&amp;gt;<a name="line.77"></a>
<span class="sourceLineNo">078</span> *              &amp;lt;LAST index="2"&amp;gt;Lincoln&amp;lt;/LAST&amp;gt;<a name="line.78"></a>
<span class="sourceLineNo">079</span> *              &amp;lt;FIRST index="3"&amp;gt;Abraham&amp;lt;/FIRST&amp;gt;<a name="line.79"></a>
<span class="sourceLineNo">080</span> *          &amp;lt;/row&amp;gt;<a name="line.80"></a>
<span class="sourceLineNo">081</span> *          ...<a name="line.81"></a>
<span class="sourceLineNo">082</span> *      &amp;lt;/data&amp;gt;<a name="line.82"></a>
<span class="sourceLineNo">083</span> *  &amp;lt;/result-set&amp;gt;<a name="line.83"></a>
<span class="sourceLineNo">084</span> * &lt;/pre&gt;<a name="line.84"></a>
<span class="sourceLineNo">085</span> * &lt;/p&gt;<a name="line.85"></a>
<span class="sourceLineNo">086</span> */<a name="line.86"></a>
<span class="sourceLineNo">087</span>public class XMLResultSetWriter {<a name="line.87"></a>
<span class="sourceLineNo">088</span><a name="line.88"></a>
<span class="sourceLineNo">089</span>    /**<a name="line.89"></a>
<span class="sourceLineNo">090</span>     * Mapping from result set {@link Types} values to their corresponding names.<a name="line.90"></a>
<span class="sourceLineNo">091</span>     */<a name="line.91"></a>
<span class="sourceLineNo">092</span>    public static final Map&lt;Integer, String&gt; TYPE_NAMES;<a name="line.92"></a>
<span class="sourceLineNo">093</span>    static {<a name="line.93"></a>
<span class="sourceLineNo">094</span>        HashMap&lt;Integer, String&gt; map = new HashMap&lt;Integer, String&gt;();<a name="line.94"></a>
<span class="sourceLineNo">095</span>        for (Field field : Types.class.getDeclaredFields()) {<a name="line.95"></a>
<span class="sourceLineNo">096</span>            if (field.getType() != Integer.TYPE || field.getModifiers() != (Modifier.PUBLIC | Modifier.STATIC | Modifier.FINAL))<a name="line.96"></a>
<span class="sourceLineNo">097</span>                continue;<a name="line.97"></a>
<span class="sourceLineNo">098</span>            try {<a name="line.98"></a>
<span class="sourceLineNo">099</span>                map.put(field.getInt(null), field.getName());<a name="line.99"></a>
<span class="sourceLineNo">100</span>            } catch (IllegalAccessException e) {<a name="line.100"></a>
<span class="sourceLineNo">101</span>                throw new RuntimeException(e);<a name="line.101"></a>
<span class="sourceLineNo">102</span>            }<a name="line.102"></a>
<span class="sourceLineNo">103</span>        }<a name="line.103"></a>
<span class="sourceLineNo">104</span>        TYPE_NAMES = Collections.unmodifiableMap(map);<a name="line.104"></a>
<span class="sourceLineNo">105</span>    }<a name="line.105"></a>
<span class="sourceLineNo">106</span><a name="line.106"></a>
<span class="sourceLineNo">107</span>    private static final String DATE_FORMAT = "yyyy-MM-dd";<a name="line.107"></a>
<span class="sourceLineNo">108</span>    private static final String TIMESTAMP_FORMAT = DATE_FORMAT + " HH:mm:ss";<a name="line.108"></a>
<span class="sourceLineNo">109</span><a name="line.109"></a>
<span class="sourceLineNo">110</span>    private final XMLStreamWriter writer;<a name="line.110"></a>
<span class="sourceLineNo">111</span>    private final String indentSpace;<a name="line.111"></a>
<span class="sourceLineNo">112</span><a name="line.112"></a>
<span class="sourceLineNo">113</span>    private State state = State.LAST_CLOSE;<a name="line.113"></a>
<span class="sourceLineNo">114</span>    private boolean columnNameTags;<a name="line.114"></a>
<span class="sourceLineNo">115</span>    private int nesting;<a name="line.115"></a>
<span class="sourceLineNo">116</span><a name="line.116"></a>
<span class="sourceLineNo">117</span>    // Tracks state of the output<a name="line.117"></a>
<span class="sourceLineNo">118</span>    private enum State {<a name="line.118"></a>
<span class="sourceLineNo">119</span>        LAST_OPEN,<a name="line.119"></a>
<span class="sourceLineNo">120</span>        LAST_CLOSE,<a name="line.120"></a>
<span class="sourceLineNo">121</span>        LAST_TEXT<a name="line.121"></a>
<span class="sourceLineNo">122</span>    };<a name="line.122"></a>
<span class="sourceLineNo">123</span><a name="line.123"></a>
<span class="sourceLineNo">124</span>    /**<a name="line.124"></a>
<span class="sourceLineNo">125</span>     * Constructor.<a name="line.125"></a>
<span class="sourceLineNo">126</span>     *<a name="line.126"></a>
<span class="sourceLineNo">127</span>     * @param writer where to write the XML<a name="line.127"></a>
<span class="sourceLineNo">128</span>     * @param indent number of spaces for indentation<a name="line.128"></a>
<span class="sourceLineNo">129</span>     * @throws IllegalArgumentException if {@code writer} is null<a name="line.129"></a>
<span class="sourceLineNo">130</span>     */<a name="line.130"></a>
<span class="sourceLineNo">131</span>    public XMLResultSetWriter(XMLStreamWriter writer, int indent) {<a name="line.131"></a>
<span class="sourceLineNo">132</span>        if (writer == null)<a name="line.132"></a>
<span class="sourceLineNo">133</span>            throw new IllegalArgumentException("null writer");<a name="line.133"></a>
<span class="sourceLineNo">134</span>        this.writer = writer;<a name="line.134"></a>
<span class="sourceLineNo">135</span>        char[] spaces = new char[indent];<a name="line.135"></a>
<span class="sourceLineNo">136</span>        Arrays.fill(spaces, ' ');<a name="line.136"></a>
<span class="sourceLineNo">137</span>        this.indentSpace = new String(spaces);<a name="line.137"></a>
<span class="sourceLineNo">138</span>    }<a name="line.138"></a>
<span class="sourceLineNo">139</span><a name="line.139"></a>
<span class="sourceLineNo">140</span>    /**<a name="line.140"></a>
<span class="sourceLineNo">141</span>     * Set whether to use the SQL column labels as the XML element names for the data columns<a name="line.141"></a>
<span class="sourceLineNo">142</span>     * instead of &lt;code&gt;&amp;lt;column&amp;gt;&lt;/code&gt;.<a name="line.142"></a>
<span class="sourceLineNo">143</span>     * Default is false.<a name="line.143"></a>
<span class="sourceLineNo">144</span>     */<a name="line.144"></a>
<span class="sourceLineNo">145</span>    public void setColumnNameTags(boolean columnNameTags) {<a name="line.145"></a>
<span class="sourceLineNo">146</span>        this.columnNameTags = columnNameTags;<a name="line.146"></a>
<span class="sourceLineNo">147</span>    }<a name="line.147"></a>
<span class="sourceLineNo">148</span><a name="line.148"></a>
<span class="sourceLineNo">149</span>    /**<a name="line.149"></a>
<span class="sourceLineNo">150</span>     * Write the given {@link ResultSet} out within a &lt;code&gt;&amp;lt;result-set&amp;gt;&lt;/code&gt; XML element.<a name="line.150"></a>
<span class="sourceLineNo">151</span>     *<a name="line.151"></a>
<span class="sourceLineNo">152</span>     * &lt;p&gt;<a name="line.152"></a>
<span class="sourceLineNo">153</span>     * This is a convenience method, equivalent to:<a name="line.153"></a>
<span class="sourceLineNo">154</span>     *  &lt;blockquote&gt;&lt;code&gt;<a name="line.154"></a>
<span class="sourceLineNo">155</span>     *      write(null, resultSet)<a name="line.155"></a>
<span class="sourceLineNo">156</span>     *  &lt;/code&gt;&lt;/blockquote&gt;<a name="line.156"></a>
<span class="sourceLineNo">157</span>     * element is included.<a name="line.157"></a>
<span class="sourceLineNo">158</span>     */<a name="line.158"></a>
<span class="sourceLineNo">159</span>    public void write(ResultSet resultSet) throws SQLException, XMLStreamException {<a name="line.159"></a>
<span class="sourceLineNo">160</span>        this.write(null, resultSet);<a name="line.160"></a>
<span class="sourceLineNo">161</span>    }<a name="line.161"></a>
<span class="sourceLineNo">162</span><a name="line.162"></a>
<span class="sourceLineNo">163</span>    /**<a name="line.163"></a>
<span class="sourceLineNo">164</span>     * Write the given {@link ResultSet} out within a &lt;code&gt;&amp;lt;result-set&amp;gt;&lt;/code&gt; XML element including the query.<a name="line.164"></a>
<span class="sourceLineNo">165</span>     * The given SQL query will be present as a &lt;code&gt;&amp;lt;query&amp;gt;&lt;/code&gt; first child element,<a name="line.165"></a>
<span class="sourceLineNo">166</span>     * followed by a &lt;code&gt;&amp;lt;columns&amp;gt;&lt;/code&gt; element containing column meta-data, and finally<a name="line.166"></a>
<span class="sourceLineNo">167</span>     * the &lt;code&gt;&amp;lt;data&amp;gt;&lt;/code&gt; element containing each returned row.<a name="line.167"></a>
<span class="sourceLineNo">168</span>     *<a name="line.168"></a>
<span class="sourceLineNo">169</span>     * &lt;p&gt;<a name="line.169"></a>
<span class="sourceLineNo">170</span>     * This method just outputs an XML element. To output an entire XML document, you would do something like this:<a name="line.170"></a>
<span class="sourceLineNo">171</span>     * &lt;pre&gt;<a name="line.171"></a>
<span class="sourceLineNo">172</span>     *  XMLResultSetWriter xmlResultSetWriter = new XMLResultSetWriter(writer, 4);<a name="line.172"></a>
<span class="sourceLineNo">173</span>     *  writer.writeStartDocument("UTF-8", "1.0");<a name="line.173"></a>
<span class="sourceLineNo">174</span>     *  xmlResultSetWriter.write(query, resultSet);<a name="line.174"></a>
<span class="sourceLineNo">175</span>     *  writer.writeEndDocument();<a name="line.175"></a>
<span class="sourceLineNo">176</span>     * &lt;/pre&gt;<a name="line.176"></a>
<span class="sourceLineNo">177</span>     * &lt;/p&gt;<a name="line.177"></a>
<span class="sourceLineNo">178</span>     *<a name="line.178"></a>
<span class="sourceLineNo">179</span>     * &lt;p&gt;<a name="line.179"></a>
<span class="sourceLineNo">180</span>     * The result set is iterated in a forward direction only.<a name="line.180"></a>
<span class="sourceLineNo">181</span>     *<a name="line.181"></a>
<span class="sourceLineNo">182</span>     * @param query the SQL query, or null to omit<a name="line.182"></a>
<span class="sourceLineNo">183</span>     * @param resultSet result of the query<a name="line.183"></a>
<span class="sourceLineNo">184</span>     * @throws XMLStreamException if there is an error writing out the XML<a name="line.184"></a>
<span class="sourceLineNo">185</span>     * @throws SQLException if there is an error reading from {@code resultSet}<a name="line.185"></a>
<span class="sourceLineNo">186</span>     */<a name="line.186"></a>
<span class="sourceLineNo">187</span>    public void write(String query, ResultSet resultSet) throws SQLException, XMLStreamException {<a name="line.187"></a>
<span class="sourceLineNo">188</span><a name="line.188"></a>
<span class="sourceLineNo">189</span>        // Start result set<a name="line.189"></a>
<span class="sourceLineNo">190</span>        this.openTag("result-set");<a name="line.190"></a>
<span class="sourceLineNo">191</span><a name="line.191"></a>
<span class="sourceLineNo">192</span>        // Emit query<a name="line.192"></a>
<span class="sourceLineNo">193</span>        if (query != null) {<a name="line.193"></a>
<span class="sourceLineNo">194</span>            this.openTag("query");<a name="line.194"></a>
<span class="sourceLineNo">195</span>            this.emitCData(query);<a name="line.195"></a>
<span class="sourceLineNo">196</span>            this.closeTag();<a name="line.196"></a>
<span class="sourceLineNo">197</span>        }<a name="line.197"></a>
<span class="sourceLineNo">198</span><a name="line.198"></a>
<span class="sourceLineNo">199</span>        // Emit column info<a name="line.199"></a>
<span class="sourceLineNo">200</span>        final ResultSetMetaData metaData = resultSet.getMetaData();<a name="line.200"></a>
<span class="sourceLineNo">201</span>        final int numColumns = metaData.getColumnCount();<a name="line.201"></a>
<span class="sourceLineNo">202</span>        String[] columnNames = new String[numColumns];<a name="line.202"></a>
<span class="sourceLineNo">203</span>        this.openTag("columns");<a name="line.203"></a>
<span class="sourceLineNo">204</span>        for (int col = 1; col &lt;= numColumns; col++) {<a name="line.204"></a>
<span class="sourceLineNo">205</span>            this.openTag("column");<a name="line.205"></a>
<span class="sourceLineNo">206</span>            this.writer.writeAttribute("index", "" + col);<a name="line.206"></a>
<span class="sourceLineNo">207</span>            String name = metaData.getColumnName(col);<a name="line.207"></a>
<span class="sourceLineNo">208</span>            if (name != null)<a name="line.208"></a>
<span class="sourceLineNo">209</span>                this.writer.writeAttribute("name", name);<a name="line.209"></a>
<span class="sourceLineNo">210</span>            String label = metaData.getColumnLabel(col);<a name="line.210"></a>
<span class="sourceLineNo">211</span>            if (label != null)<a name="line.211"></a>
<span class="sourceLineNo">212</span>                this.writer.writeAttribute("label", label);<a name="line.212"></a>
<span class="sourceLineNo">213</span>            if (this.columnNameTags)<a name="line.213"></a>
<span class="sourceLineNo">214</span>                columnNames[col - 1] = label != null ? label : name != null ? name : null;<a name="line.214"></a>
<span class="sourceLineNo">215</span>            int precision = metaData.getPrecision(col);<a name="line.215"></a>
<span class="sourceLineNo">216</span>            if (precision != 0)<a name="line.216"></a>
<span class="sourceLineNo">217</span>                this.writer.writeAttribute("precision", "" + precision);<a name="line.217"></a>
<span class="sourceLineNo">218</span>            int scale = metaData.getScale(col);<a name="line.218"></a>
<span class="sourceLineNo">219</span>            if (scale != 0)<a name="line.219"></a>
<span class="sourceLineNo">220</span>                this.writer.writeAttribute("scale", "" + scale);<a name="line.220"></a>
<span class="sourceLineNo">221</span>            int type = metaData.getColumnType(col);<a name="line.221"></a>
<span class="sourceLineNo">222</span>            final String typeName = XMLResultSetWriter.TYPE_NAMES.get(type);<a name="line.222"></a>
<span class="sourceLineNo">223</span>            this.writer.writeAttribute("type", typeName != null ? typeName : "" + type);<a name="line.223"></a>
<span class="sourceLineNo">224</span>            this.writer.writeAttribute("typeName", metaData.getColumnTypeName(col));<a name="line.224"></a>
<span class="sourceLineNo">225</span>            String nullableDesc;<a name="line.225"></a>
<span class="sourceLineNo">226</span>            switch (metaData.isNullable(col)) {<a name="line.226"></a>
<span class="sourceLineNo">227</span>            case ResultSetMetaData.columnNullable:<a name="line.227"></a>
<span class="sourceLineNo">228</span>                nullableDesc = "true";<a name="line.228"></a>
<span class="sourceLineNo">229</span>                break;<a name="line.229"></a>
<span class="sourceLineNo">230</span>            case ResultSetMetaData.columnNoNulls:<a name="line.230"></a>
<span class="sourceLineNo">231</span>                nullableDesc = "false";<a name="line.231"></a>
<span class="sourceLineNo">232</span>                break;<a name="line.232"></a>
<span class="sourceLineNo">233</span>            default:<a name="line.233"></a>
<span class="sourceLineNo">234</span>                nullableDesc = "unknown";<a name="line.234"></a>
<span class="sourceLineNo">235</span>                break;<a name="line.235"></a>
<span class="sourceLineNo">236</span>            }<a name="line.236"></a>
<span class="sourceLineNo">237</span>            this.writer.writeAttribute("nullable", nullableDesc);<a name="line.237"></a>
<span class="sourceLineNo">238</span>            this.closeTag();<a name="line.238"></a>
<span class="sourceLineNo">239</span>        }<a name="line.239"></a>
<span class="sourceLineNo">240</span>        this.closeTag();<a name="line.240"></a>
<span class="sourceLineNo">241</span><a name="line.241"></a>
<span class="sourceLineNo">242</span>        // Emit result data<a name="line.242"></a>
<span class="sourceLineNo">243</span>        this.openTag("data");<a name="line.243"></a>
<span class="sourceLineNo">244</span>        while (resultSet.next()) {<a name="line.244"></a>
<span class="sourceLineNo">245</span>            this.openTag("row");<a name="line.245"></a>
<span class="sourceLineNo">246</span>            for (int col = 1; col &lt;= numColumns; col++)<a name="line.246"></a>
<span class="sourceLineNo">247</span>                this.writeDataColumn(resultSet, metaData.getColumnType(col), col, columnNames[col - 1]);<a name="line.247"></a>
<span class="sourceLineNo">248</span>            this.closeTag();<a name="line.248"></a>
<span class="sourceLineNo">249</span>        }<a name="line.249"></a>
<span class="sourceLineNo">250</span>        this.closeTag();<a name="line.250"></a>
<span class="sourceLineNo">251</span><a name="line.251"></a>
<span class="sourceLineNo">252</span>        // End result set<a name="line.252"></a>
<span class="sourceLineNo">253</span>        this.closeTag();<a name="line.253"></a>
<span class="sourceLineNo">254</span>    }<a name="line.254"></a>
<span class="sourceLineNo">255</span><a name="line.255"></a>
<span class="sourceLineNo">256</span>// Writing a data row<a name="line.256"></a>
<span class="sourceLineNo">257</span><a name="line.257"></a>
<span class="sourceLineNo">258</span>    private void writeDataColumn(ResultSet resultSet, int columnType, int col, String columnName)<a name="line.258"></a>
<span class="sourceLineNo">259</span>      throws SQLException, XMLStreamException {<a name="line.259"></a>
<span class="sourceLineNo">260</span>        Object value = null;<a name="line.260"></a>
<span class="sourceLineNo">261</span>        switch (columnType) {<a name="line.261"></a>
<span class="sourceLineNo">262</span>        case Types.BIT:<a name="line.262"></a>
<span class="sourceLineNo">263</span>        case Types.BOOLEAN:<a name="line.263"></a>
<span class="sourceLineNo">264</span>        {<a name="line.264"></a>
<span class="sourceLineNo">265</span>            boolean b = resultSet.getBoolean(col);<a name="line.265"></a>
<span class="sourceLineNo">266</span>            if (!resultSet.wasNull())<a name="line.266"></a>
<span class="sourceLineNo">267</span>                value = "" + b;<a name="line.267"></a>
<span class="sourceLineNo">268</span>            break;<a name="line.268"></a>
<span class="sourceLineNo">269</span>        }<a name="line.269"></a>
<span class="sourceLineNo">270</span>        case Types.CLOB:<a name="line.270"></a>
<span class="sourceLineNo">271</span>        case Types.NCLOB:<a name="line.271"></a>
<span class="sourceLineNo">272</span>        case Types.LONGVARCHAR:<a name="line.272"></a>
<span class="sourceLineNo">273</span>        case Types.LONGNVARCHAR:<a name="line.273"></a>
<span class="sourceLineNo">274</span>        case Types.VARCHAR:<a name="line.274"></a>
<span class="sourceLineNo">275</span>        case Types.NVARCHAR:<a name="line.275"></a>
<span class="sourceLineNo">276</span>        case Types.CHAR:<a name="line.276"></a>
<span class="sourceLineNo">277</span>        case Types.NCHAR:<a name="line.277"></a>
<span class="sourceLineNo">278</span>        {<a name="line.278"></a>
<span class="sourceLineNo">279</span>            Reader reader = resultSet.getCharacterStream(col);<a name="line.279"></a>
<span class="sourceLineNo">280</span>            if (reader == null)<a name="line.280"></a>
<span class="sourceLineNo">281</span>                break;<a name="line.281"></a>
<span class="sourceLineNo">282</span>            int len;<a name="line.282"></a>
<span class="sourceLineNo">283</span>            char[] buf = new char[1024];<a name="line.283"></a>
<span class="sourceLineNo">284</span>            this.openColumnTag(col, columnName);<a name="line.284"></a>
<span class="sourceLineNo">285</span>            try {<a name="line.285"></a>
<span class="sourceLineNo">286</span>                while ((len = reader.read(buf)) != -1)<a name="line.286"></a>
<span class="sourceLineNo">287</span>                    this.emitText(buf, 0, len);<a name="line.287"></a>
<span class="sourceLineNo">288</span>                reader.close();<a name="line.288"></a>
<span class="sourceLineNo">289</span>            } catch (IOException e) {<a name="line.289"></a>
<span class="sourceLineNo">290</span>                throw (SQLException)new SQLException("error reading from CLOB").initCause(e);<a name="line.290"></a>
<span class="sourceLineNo">291</span>            }<a name="line.291"></a>
<span class="sourceLineNo">292</span>            this.closeTag();<a name="line.292"></a>
<span class="sourceLineNo">293</span>            return;<a name="line.293"></a>
<span class="sourceLineNo">294</span>        }<a name="line.294"></a>
<span class="sourceLineNo">295</span>        case Types.BIGINT:<a name="line.295"></a>
<span class="sourceLineNo">296</span>        case Types.DECIMAL:<a name="line.296"></a>
<span class="sourceLineNo">297</span>        case Types.DOUBLE:<a name="line.297"></a>
<span class="sourceLineNo">298</span>        case Types.FLOAT:<a name="line.298"></a>
<span class="sourceLineNo">299</span>        case Types.REAL:<a name="line.299"></a>
<span class="sourceLineNo">300</span>        case Types.NUMERIC:<a name="line.300"></a>
<span class="sourceLineNo">301</span>            value = resultSet.getBigDecimal(col);<a name="line.301"></a>
<span class="sourceLineNo">302</span>            break;<a name="line.302"></a>
<span class="sourceLineNo">303</span>        case Types.INTEGER:<a name="line.303"></a>
<span class="sourceLineNo">304</span>        case Types.TINYINT:<a name="line.304"></a>
<span class="sourceLineNo">305</span>        case Types.SMALLINT:<a name="line.305"></a>
<span class="sourceLineNo">306</span>            value = resultSet.getInt(col);<a name="line.306"></a>
<span class="sourceLineNo">307</span>            break;<a name="line.307"></a>
<span class="sourceLineNo">308</span>        case Types.DATE:<a name="line.308"></a>
<span class="sourceLineNo">309</span>        {<a name="line.309"></a>
<span class="sourceLineNo">310</span>            Date date = resultSet.getDate(col);<a name="line.310"></a>
<span class="sourceLineNo">311</span>            if (date != null)<a name="line.311"></a>
<span class="sourceLineNo">312</span>                value = new SimpleDateFormat(DATE_FORMAT).format(date);<a name="line.312"></a>
<span class="sourceLineNo">313</span>            break;<a name="line.313"></a>
<span class="sourceLineNo">314</span>        }<a name="line.314"></a>
<span class="sourceLineNo">315</span>        case Types.TIME:<a name="line.315"></a>
<span class="sourceLineNo">316</span>            value = resultSet.getTime(col);<a name="line.316"></a>
<span class="sourceLineNo">317</span>            break;<a name="line.317"></a>
<span class="sourceLineNo">318</span>        case Types.TIMESTAMP:<a name="line.318"></a>
<span class="sourceLineNo">319</span>        {<a name="line.319"></a>
<span class="sourceLineNo">320</span>            Timestamp timestamp = resultSet.getTimestamp(col);<a name="line.320"></a>
<span class="sourceLineNo">321</span>            if (timestamp != null)<a name="line.321"></a>
<span class="sourceLineNo">322</span>                value = new SimpleDateFormat(TIMESTAMP_FORMAT).format(timestamp);<a name="line.322"></a>
<span class="sourceLineNo">323</span>            break;<a name="line.323"></a>
<span class="sourceLineNo">324</span>        }<a name="line.324"></a>
<span class="sourceLineNo">325</span>        case Types.BLOB:<a name="line.325"></a>
<span class="sourceLineNo">326</span>        case Types.BINARY:<a name="line.326"></a>
<span class="sourceLineNo">327</span>        case Types.VARBINARY:<a name="line.327"></a>
<span class="sourceLineNo">328</span>        case Types.LONGVARBINARY:<a name="line.328"></a>
<span class="sourceLineNo">329</span>        {<a name="line.329"></a>
<span class="sourceLineNo">330</span>            InputStream input = resultSet.getBinaryStream(col);<a name="line.330"></a>
<span class="sourceLineNo">331</span>            if (input == null)<a name="line.331"></a>
<span class="sourceLineNo">332</span>                break;<a name="line.332"></a>
<span class="sourceLineNo">333</span>            this.openColumnTag(col, columnName);<a name="line.333"></a>
<span class="sourceLineNo">334</span>            try {<a name="line.334"></a>
<span class="sourceLineNo">335</span>                this.writeBinary(input);<a name="line.335"></a>
<span class="sourceLineNo">336</span>                input.close();<a name="line.336"></a>
<span class="sourceLineNo">337</span>            } catch (IOException e) {<a name="line.337"></a>
<span class="sourceLineNo">338</span>                throw (SQLException)new SQLException("error reading from BLOB").initCause(e);<a name="line.338"></a>
<span class="sourceLineNo">339</span>            }<a name="line.339"></a>
<span class="sourceLineNo">340</span>            this.closeTag();<a name="line.340"></a>
<span class="sourceLineNo">341</span>            return;<a name="line.341"></a>
<span class="sourceLineNo">342</span>        }<a name="line.342"></a>
<span class="sourceLineNo">343</span>        case Types.ROWID:<a name="line.343"></a>
<span class="sourceLineNo">344</span>        {<a name="line.344"></a>
<span class="sourceLineNo">345</span>            try {<a name="line.345"></a>
<span class="sourceLineNo">346</span>                value = resultSet.getRowId(col);<a name="line.346"></a>
<span class="sourceLineNo">347</span>            } catch (AbstractMethodError e) {<a name="line.347"></a>
<span class="sourceLineNo">348</span>                value = resultSet.getObject(col);<a name="line.348"></a>
<span class="sourceLineNo">349</span>            }<a name="line.349"></a>
<span class="sourceLineNo">350</span>            break;<a name="line.350"></a>
<span class="sourceLineNo">351</span>        }<a name="line.351"></a>
<span class="sourceLineNo">352</span>        // Unhandled cases...<a name="line.352"></a>
<span class="sourceLineNo">353</span>        case Types.ARRAY:<a name="line.353"></a>
<span class="sourceLineNo">354</span>        case Types.DATALINK:<a name="line.354"></a>
<span class="sourceLineNo">355</span>        case Types.DISTINCT:<a name="line.355"></a>
<span class="sourceLineNo">356</span>        case Types.JAVA_OBJECT:<a name="line.356"></a>
<span class="sourceLineNo">357</span>        case Types.NULL:<a name="line.357"></a>
<span class="sourceLineNo">358</span>        case Types.OTHER:<a name="line.358"></a>
<span class="sourceLineNo">359</span>        case Types.REF:<a name="line.359"></a>
<span class="sourceLineNo">360</span>        case Types.SQLXML:<a name="line.360"></a>
<span class="sourceLineNo">361</span>        case Types.STRUCT:<a name="line.361"></a>
<span class="sourceLineNo">362</span>        default:<a name="line.362"></a>
<span class="sourceLineNo">363</span>            value = resultSet.getObject(col);<a name="line.363"></a>
<span class="sourceLineNo">364</span>            break;<a name="line.364"></a>
<span class="sourceLineNo">365</span>        }<a name="line.365"></a>
<span class="sourceLineNo">366</span><a name="line.366"></a>
<span class="sourceLineNo">367</span>        // Handle null by omitting the tag entirely<a name="line.367"></a>
<span class="sourceLineNo">368</span>        if (value == null || resultSet.wasNull())<a name="line.368"></a>
<span class="sourceLineNo">369</span>            return;<a name="line.369"></a>
<span class="sourceLineNo">370</span><a name="line.370"></a>
<span class="sourceLineNo">371</span>        // Emit value<a name="line.371"></a>
<span class="sourceLineNo">372</span>        this.openColumnTag(col, columnName);<a name="line.372"></a>
<span class="sourceLineNo">373</span>        this.emitText(value.toString());<a name="line.373"></a>
<span class="sourceLineNo">374</span>        this.closeTag();<a name="line.374"></a>
<span class="sourceLineNo">375</span>    }<a name="line.375"></a>
<span class="sourceLineNo">376</span><a name="line.376"></a>
<span class="sourceLineNo">377</span>    private void writeBinary(InputStream input) throws IOException, XMLStreamException {<a name="line.377"></a>
<span class="sourceLineNo">378</span>        int len;<a name="line.378"></a>
<span class="sourceLineNo">379</span>        byte[] buf = new byte[1024];<a name="line.379"></a>
<span class="sourceLineNo">380</span>        char[] ch = new char[2];<a name="line.380"></a>
<span class="sourceLineNo">381</span>        while ((len = input.read(buf)) != -1) {<a name="line.381"></a>
<span class="sourceLineNo">382</span>            for (int i = 0; i &lt; len; i++) {<a name="line.382"></a>
<span class="sourceLineNo">383</span>                int val = buf[i] &amp; 0xff;<a name="line.383"></a>
<span class="sourceLineNo">384</span>                ch[0] = Character.forDigit(val &gt;&gt; 4, 16);<a name="line.384"></a>
<span class="sourceLineNo">385</span>                ch[1] = Character.forDigit(val &amp; 0xf, 16);<a name="line.385"></a>
<span class="sourceLineNo">386</span>                this.emitText(ch, 0, 2);<a name="line.386"></a>
<span class="sourceLineNo">387</span>            }<a name="line.387"></a>
<span class="sourceLineNo">388</span>        }<a name="line.388"></a>
<span class="sourceLineNo">389</span>    }<a name="line.389"></a>
<span class="sourceLineNo">390</span><a name="line.390"></a>
<span class="sourceLineNo">391</span>// XML output formatting<a name="line.391"></a>
<span class="sourceLineNo">392</span><a name="line.392"></a>
<span class="sourceLineNo">393</span>    private void openColumnTag(int col, String columnName) throws XMLStreamException {<a name="line.393"></a>
<span class="sourceLineNo">394</span>        this.openTag(columnName != null ? this.xmlify(columnName) : "column");<a name="line.394"></a>
<span class="sourceLineNo">395</span>        this.emitAttr("index", "" + col);<a name="line.395"></a>
<span class="sourceLineNo">396</span>    }<a name="line.396"></a>
<span class="sourceLineNo">397</span><a name="line.397"></a>
<span class="sourceLineNo">398</span>    private String xmlify(String name) {<a name="line.398"></a>
<span class="sourceLineNo">399</span>        StringBuilder buf = new StringBuilder(name.length());<a name="line.399"></a>
<span class="sourceLineNo">400</span>        for (int i = 0; i &lt; name.length(); i++) {<a name="line.400"></a>
<span class="sourceLineNo">401</span>            final char ch = name.charAt(i);<a name="line.401"></a>
<span class="sourceLineNo">402</span>            if (Character.isLetter(ch) || ch == '_' || ch == ':') {<a name="line.402"></a>
<span class="sourceLineNo">403</span>                buf.append(ch);<a name="line.403"></a>
<span class="sourceLineNo">404</span>                continue;<a name="line.404"></a>
<span class="sourceLineNo">405</span>            }<a name="line.405"></a>
<span class="sourceLineNo">406</span>            if (i &gt; 0 &amp;&amp; (Character.isDigit(ch) || ch == '.' || ch == '-')) {<a name="line.406"></a>
<span class="sourceLineNo">407</span>                buf.append(ch);<a name="line.407"></a>
<span class="sourceLineNo">408</span>                continue;<a name="line.408"></a>
<span class="sourceLineNo">409</span>            }<a name="line.409"></a>
<span class="sourceLineNo">410</span>            buf.append('_');<a name="line.410"></a>
<span class="sourceLineNo">411</span>        }<a name="line.411"></a>
<span class="sourceLineNo">412</span>        return buf.toString();<a name="line.412"></a>
<span class="sourceLineNo">413</span>    }<a name="line.413"></a>
<span class="sourceLineNo">414</span><a name="line.414"></a>
<span class="sourceLineNo">415</span>    private void openTag(String name) throws XMLStreamException {<a name="line.415"></a>
<span class="sourceLineNo">416</span>        switch (this.state) {<a name="line.416"></a>
<span class="sourceLineNo">417</span>        case LAST_OPEN:<a name="line.417"></a>
<span class="sourceLineNo">418</span>            this.writer.writeCharacters("\n");<a name="line.418"></a>
<span class="sourceLineNo">419</span>            break;<a name="line.419"></a>
<span class="sourceLineNo">420</span>        case LAST_CLOSE:<a name="line.420"></a>
<span class="sourceLineNo">421</span>            break;<a name="line.421"></a>
<span class="sourceLineNo">422</span>        case LAST_TEXT:<a name="line.422"></a>
<span class="sourceLineNo">423</span>        default:<a name="line.423"></a>
<span class="sourceLineNo">424</span>            throw new RuntimeException("mixed element content not supported");<a name="line.424"></a>
<span class="sourceLineNo">425</span>        }<a name="line.425"></a>
<span class="sourceLineNo">426</span>        for (int i = 0; i &lt; this.nesting; i++)<a name="line.426"></a>
<span class="sourceLineNo">427</span>            this.writer.writeCharacters(this.indentSpace);<a name="line.427"></a>
<span class="sourceLineNo">428</span>        this.writer.writeStartElement(name);<a name="line.428"></a>
<span class="sourceLineNo">429</span>        this.nesting++;<a name="line.429"></a>
<span class="sourceLineNo">430</span>        this.state = State.LAST_OPEN;<a name="line.430"></a>
<span class="sourceLineNo">431</span>    }<a name="line.431"></a>
<span class="sourceLineNo">432</span><a name="line.432"></a>
<span class="sourceLineNo">433</span>    private void emitAttr(String name, String value) throws XMLStreamException {<a name="line.433"></a>
<span class="sourceLineNo">434</span>        this.writer.writeAttribute(name, value);<a name="line.434"></a>
<span class="sourceLineNo">435</span>    }<a name="line.435"></a>
<span class="sourceLineNo">436</span><a name="line.436"></a>
<span class="sourceLineNo">437</span>    private void emitText(String content) throws XMLStreamException {<a name="line.437"></a>
<span class="sourceLineNo">438</span>        this.writer.writeCharacters(content);<a name="line.438"></a>
<span class="sourceLineNo">439</span>        this.state = State.LAST_TEXT;<a name="line.439"></a>
<span class="sourceLineNo">440</span>    }<a name="line.440"></a>
<span class="sourceLineNo">441</span><a name="line.441"></a>
<span class="sourceLineNo">442</span>    private void emitText(char[] buf, int off, int len) throws XMLStreamException {<a name="line.442"></a>
<span class="sourceLineNo">443</span>        this.writer.writeCharacters(buf, off, len);<a name="line.443"></a>
<span class="sourceLineNo">444</span>        this.state = State.LAST_TEXT;<a name="line.444"></a>
<span class="sourceLineNo">445</span>    }<a name="line.445"></a>
<span class="sourceLineNo">446</span><a name="line.446"></a>
<span class="sourceLineNo">447</span>    private void emitCData(String content) throws XMLStreamException {<a name="line.447"></a>
<span class="sourceLineNo">448</span>        this.writer.writeCData(content);<a name="line.448"></a>
<span class="sourceLineNo">449</span>        this.state = State.LAST_TEXT;<a name="line.449"></a>
<span class="sourceLineNo">450</span>    }<a name="line.450"></a>
<span class="sourceLineNo">451</span><a name="line.451"></a>
<span class="sourceLineNo">452</span>    private void closeTag() throws XMLStreamException {<a name="line.452"></a>
<span class="sourceLineNo">453</span>        this.nesting--;<a name="line.453"></a>
<span class="sourceLineNo">454</span>        if (this.state == State.LAST_CLOSE) {<a name="line.454"></a>
<span class="sourceLineNo">455</span>            for (int i = 0; i &lt; this.nesting; i++)<a name="line.455"></a>
<span class="sourceLineNo">456</span>                this.writer.writeCharacters(this.indentSpace);<a name="line.456"></a>
<span class="sourceLineNo">457</span>        }<a name="line.457"></a>
<span class="sourceLineNo">458</span>        this.writer.writeEndElement();<a name="line.458"></a>
<span class="sourceLineNo">459</span>        if (this.nesting &gt; 0)<a name="line.459"></a>
<span class="sourceLineNo">460</span>            this.writer.writeCharacters("\n");<a name="line.460"></a>
<span class="sourceLineNo">461</span>        this.state = State.LAST_CLOSE;<a name="line.461"></a>
<span class="sourceLineNo">462</span>    }<a name="line.462"></a>
<span class="sourceLineNo">463</span>}<a name="line.463"></a>
<span class="sourceLineNo">464</span><a name="line.464"></a>




























































</pre>
</div>
</body>
</html>
